String[].FindSorted (gb)

Function FindSorted ( Value As String [ , Mode As Integer, Start As Integer ] ) As Integer

Since 3.16

Returns the position of Value in a sorted array.

  • The Mode argument is one of the comparison methods available. See Predefined Constants for a list of comparison methods.

  • If Start is specified, then the search begins at the Start position. By default the entire array is searched.

If Value cannot be found, a negative value is returned. It equals -1 - pos, where pos is the position Value should be inserted at to keep the array sorted.

This method only works if the array is sorted.

Moreover, if Value is not unique, the returned position is not necessarily the first one.

But it is faster than the Find method as it uses a binary search algorithm.